var createError = require('http-errors');
var express = require('express');
var path = require('path');
var cookieParser = require('cookie-parser');
var logger = require('morgan');
var cors = require('cors');
var indexRouter = require('./routes/index');
var usersRouter = require('./routes/users');
var sqlite3 = require('sqlite3').verbose();
var app = express();

// view engine setup
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'jade');

app.use(cors());
app.use(logger('dev'));
app.use(express.json());
app.use(express.urlencoded({ extended: false }));
app.use(cookieParser());
app.use(express.static(path.join(__dirname, 'public')));

app.use('/', indexRouter);
app.use('/users', usersRouter);

// catch 404 and forward to error handler
app.use(function(req, res, next) {
  next(createError(404));
});

// error handler
app.use(function(err, req, res, next) {
  // set locals, only providing error in development
  res.locals.message = err.message;
  res.locals.error = req.app.get('env') === 'development' ? err : {};

  // render the error page
  res.status(err.status || 500);
  res.render('error');
});

// // 打开或创建数据库文件
// const db = new sqlite3.Database('./db.sqlite', err => {
//   if (err) console.error('打开数据库失败：', err);
//   else     console.log('SQLite 数据库已打开');
// });

// // 初始化表（如不存在则创建）
// db.run(`
//   CREATE TABLE IF NOT EXISTS todos (
//     id   INTEGER PRIMARY KEY AUTOINCREMENT,
//     task TEXT    NOT NULL,
//     done INTEGER DEFAULT 0
//   )
// `);

module.exports = app;
